Lars Vilhuber
2015-06-16
In this short presentation,
Use any number of ZIP-compatible products to unzip (here: 7zip). Right-click, extract.
Simply double-click on both files
For simplicity, we move the sheets into the same workbook.
We focus on HirAEndR (and deleted most other columns after it)
On first tab, create columns H_low and H_high
Strict
\[ X_{low} = X_t - t(0.95,df\_X_t) st\_X_t \]
i.e.
h_low = HirAEndR –
t(df_HirAEndR,0.95)*st_HirAEndR
Approximate
\[ X_{low} = X_t - 1.645 st\_X_t \]
i.e.
h_low = HirAEndR – 1.645*st_HirAEndR
You want the yyq, HirAEndR and the high/low columns
We'll be changing it shortly anyway…
Select “Line” for main series, “Area” for bounds
(not “Stacked Area”!)
Programs to read in National QWI files and variability measures by Lars Vilhuber is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License